<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>




    <meta http-equiv="Content-Type" content="text/html;charset=utf-8"><title>OGo Docs - BIE Integration Work Flows</title>

    

    
    
       
       
          <!-- base href="http://docs.opengroupware.org/Members/whitemice/bieintegration/" --><!-- Basic crude style for Netscape4.x - This can be removed
         if you don't want the special NS4 look - it will still work,
	 just be plain text instead. -->
       
    
  


    
    <link rel="Stylesheet" type="text/css" href="BIE%20Integration%20Work%20Flows_files/ploneNS4.css"><!-- Main style sheets for CSS2 capable browsers -->

    
    <style type="text/css" media="all"> @import url(http://docs.opengroupware.org/plone.css?skin=);</style><!-- Custom style sheet if available -->

    
    <style type="text/css" media="all">@import url(http://docs.opengroupware.org/ploneCustom.css);</style><!-- Style sheet used for printing -->

    
    <link rel="stylesheet" type="text/css" media="print" href="BIE%20Integration%20Work%20Flows_files/plonePrint.css"><!-- Style sheet used for presentations (Opera is the only browser supporting this at the moment) -->

    
    <link rel="stylesheet" type="text/css" media="projection" href="BIE%20Integration%20Work%20Flows_files/plonePresentation.css">

    <link rel="shortcut icon" href="http://docs.opengroupware.org/favicon.ico" type="image/x-icon">

    <link rel="home" href="http://docs.opengroupware.org/" title="Front Page">
    <link rel="search" href="http://docs.opengroupware.org/search_form" title="Search this site"><!-- Disable IE6 image toolbar -->

    
    <meta http-equiv="imagetoolbar" content="no"><!-- Common Plone ECMAScripts -->

    
    
  

    

    
    
    
    
    

    
  

    
    
  

    
    <script type="text/javascript" src="BIE%20Integration%20Work%20Flows_files/plone_javascripts.js"></script>

    
      <script type="text/javascript" src="BIE%20Integration%20Work%20Flows_files/plone_formtooltip.js"></script></head><body>

<div>

     

        <div class="top">

            <div class="searchBox">
                <form name="searchform" action="http://docs.opengroupware.org/search">

                    <input id="searchGadget" name="SearchableText" size="20" tabindex="30001" type="text">

                    <input class="context searchButton" value="Search" tabindex="30002" type="submit">
                </form>
            </div>

            <a href="http://docs.opengroupware.org/">
                <img src="BIE%20Integration%20Work%20Flows_files/logo.jpg" class="logo" alt="" border="0" height="56" width="356">
            </a>
        </div>

        <hr class="netscape4" size="">

        <div class="tabs">

        
            <a href="http://docs.opengroupware.org/" class="plain">
                Welcome
            </a>
        
        
            <a href="http://docs.opengroupware.org/search_form" class="plain">
                Advanced Search
            </a>
        
        
            <a href="http://docs.opengroupware.org/events" class="plain">
                Events
            </a>
        
        
            <a href="http://docs.opengroupware.org/alldocs" class="plain">
                user published docs
            </a>
        
        
            <a href="http://manuals.opengroupware.org/Members/editor/userguidev09" class="plain">
                manuals
            </a>
        

        </div>

        <div class="personalBar">&nbsp;

            

            <span>You are not logged in</span>

            
            <a href="http://docs.opengroupware.org/login_form">
                <img src="BIE%20Integration%20Work%20Flows_files/linkOpaque.gif" alt="" title="" border="0" height="11" width="6">

                Log in
            </a>
            
            
            <a href="http://docs.opengroupware.org/portal_form/join_form">
                <img src="BIE%20Integration%20Work%20Flows_files/linkOpaque.gif" alt="" title="" border="0" height="11" width="6">

                Join
            </a>
            
        </div>

        <div class="pathBar">

            
	    You are here:
	        
                <a href="http://docs.opengroupware.org/">Home</a>
                <strong>»</strong>
            

            

            <span>

                

                <a href="http://docs.opengroupware.org/Members/view">Members</a>
                <strong> » </strong>
                

            </span>
            <span>

                

                <a href="http://docs.opengroupware.org/Members/whitemice/view">whitemice's Home</a>
                <strong> » </strong>
                

            </span>
            <span>

                

                <a href="http://docs.opengroupware.org/Members/whitemice/bieintegration/view">BIE Integration</a>
                <strong> » </strong>
                

            </span>
            <span>

                

                
                
                <span>BIE Integration Work Flows</span>

            </span>

        </div>

        <hr class="netscape4" size="">

    </div>


<table class="columns">

    <tbody>
        <tr>
            <td class="left">
                
                
                    

    <div class="box">

        <h5>Navigation</h5>

        <div class="body">

            
    
            
    
            <div class="content odd">
                     
                
                
                <div style="white-space: nowrap;">
            
                    <span>
                               

                        
                        
                        
                        <a href="http://docs.opengroupware.org/" title="">
                           
                            <img src="BIE%20Integration%20Work%20Flows_files/site_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OGo Docs
                        </a>
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/alldocs/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/topic_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;All Docs
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;Members
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;whitemice's Home
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                           <span class="currentNavItem">
                        </span>
                        <a href="http://docs.opengroupware.org/Members/whitemice/bieintegration/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;<span class="currentNavItem">BIE Integration</span>
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/bieintegration/jython/" class="plain" title="Querying OGo Via Jython">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;Querying OGo Via J
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/consonance/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;C#/GTK# Client
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/mono/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OGo &amp; Mono (C#)
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/ogo-n-php/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OGo &amp; PHP
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/OGoMojo/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OGoMojo Releases
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/ogoxmlunload/" class="plain" title="">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OGoUnload
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/presentation/" class="plain" title="OpenGroupware KLUG Presentation">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OpenGroupware KLUG
                        </a>
                        
                        
                    </span>
                </div>
                <div style="white-space: nowrap;">
            
                    <span>
                               
                        &nbsp;
                        &nbsp;
                        &nbsp;

                        
                        <a href="http://docs.opengroupware.org/Members/whitemice/OGo-Back-SQL/" class="plain" title="OpenLDAP 2.1.x Back SQL Recipe">
                
                            <img src="BIE%20Integration%20Work%20Flows_files/folder_icon.gif" alt="" title="" border="0" height="16" width="16">&nbsp;OpenLDAP 2.1.x Bac
                        </a>
                        
                        
                    </span>
                </div>
                
    
            </div>

        </div>

    </div>


                
                
                
                
                
                    

    <div class="box">

        <h5>Log in</h5>

        <div class="body">
        
            <div class="content odd">
                <form action="http://docs.opengroupware.org/logged_in" method="post">
    
                    
    
                    <strong>Name</strong> <br>
                    <input style="background-color: rgb(255, 255, 160);" name="__ac_name" size="12" tabindex="10001" value="" type="text">
    
                    <br>
    
                    <strong>Password</strong>  <br>
                    <input name="__ac_password" size="12" tabindex="10002" type="password">
    
                    <br>
                    &nbsp;
                    <br>
    
                    <input class="context searchButton" name="submit" value="Log in" tabindex="10003" type="submit">
                </form>
            </div>
    
            <div class="content even"> 
                <a href="http://docs.opengroupware.org/mail_password_form">
                   <img src="BIE%20Integration%20Work%20Flows_files/linkTransparent.gif" alt="" title="" border="0" height="11" width="6">
                   Forgot your password?
                </a>
            </div>

            <div class="content odd">
          
                <a href="http://docs.opengroupware.org/portal_form/join_form">
                    <img src="BIE%20Integration%20Work%20Flows_files/linkTransparent.gif" alt="" title="" border="0" height="11" width="6">
                    New user?
                </a>
    
            </div>

        </div>
        
    </div>


                
                
                
                
                
                    <div>

    <div class="box">

        <h5>Related</h5>
    
        <div class="body">

            
          
            <div class="content even">
                <strong>External links</strong>
                <div>
                        <a href="http://www.brunswickwdi.com/bie">BIE Home Page</a>
                </div>
            </div>

        </div>

    </div>

</div>
                
                
                
            </td>
            <td class="main">

                

                <div class="document">

                    <div id="content">

                        

                        <div class="documentActions">

                            

                            <a href="http://docs.opengroupware.org/Members/whitemice/bieintegration/workflows/portal_form/sendto_form">
                                <img alt="Send to" src="BIE%20Integration%20Work%20Flows_files/mail_icon.gif" title="Send this page to somebody">
                            </a>

                            <a href="javascript:this.print();">
                                <img alt="Print" src="BIE%20Integration%20Work%20Flows_files/print_icon.gif" title="Print this page">
                            </a>
                        </div>

                        

                        <div>

    <h1>BIE Integration Work Flows</h1>

    <div class="description">Description of the provided BPML files that can be used to create a BIE workflow.</div>

    

    <div class="stx">
A note on datasources: You will need to adjust the datasource names to
match your own. These routes assume (primarily, unless otherwise noted)
two datasources: a connection to your OpenGroupware database called
"OpenGroupware" and a connection to a foriegn database called "MOA".
The name of your foriegn database will almost certainly be different.
<br>
<br>You also will need to change the e-mail address used in the
exception actions, since you probably don't want a backtrace of your
exception events e-mailed to us! :)
<br>
<br>Syncronization workflows (from OpenGroupware to your foriegn database).
<br>
<br>NOTE: None of these flows handle removal of teams, accounts, or projects.  They only process updates and creations.
<br>
<br>OGoSyncAccounts
<br>---------------
<br>The route populates the table ogo_account (see below) in your
foriegn database with the account information from the OpenGroupware
database. The account_id is the "company_id" from the OpenGroupware
database and is used as the persitent identifier for an account. If
account_id already exists and UPDATE is performed on ogo_account,
otherwise an INSERT is performed to create the account.
<br>
<br>CREATE TABLE ogo_account (
<br>  account_id  INT PRIMARY KEY,
<br>  login       VARCHAR(20) NOT NULL,
<br>  number      VARCHAR(20),
<br>  firstname   VARCHAR(20),
<br>  lastname    VARCHAR(45));
<br>
<br>OGoSyncTeams
<br>------------
<br>This route requires the ogo_account table to be current.
<br>
<br>This route populates the ogo_team table (see below) in your foriegn
database with team information from the OpenGroupware database. The
team_id is the "company_id" from the OpenGroupware databse and is used
as the persistent identifier for the team. If the team_id already
exists an UPDATE is performed on the team name, otherwise an INSERT is
performed to create the team. For each team, once the update or insert
has been performed, the route retrieves a list of all members (from
company_assignment in the OpenGroupware database) and syncronizes the
team_membership table adding any members not present and removing any
members that no longer are recorded as members in OpenGroupware.
<br>
<br>CREATE TABLE ogo_team (
<br>  team_id  INT PRIMARY KEY,
<br>  name     VARCHAR(60));
<br>
<br>CREATE TABLE ogo_team_membership (
<br>  account_id  INT REFERENCES ogo_account,
<br>  team_id     INT REFERENCES ogo_team,
<br>   PRIMARY KEY(account_id, team_id));
<br>
<br>OGoSyncProjects
<br>----------------
<br>This route populates the ogo_project (see below) in your forign
database with project information from the OpenGroupware database. The
project_id is the project_is fromt he OpenGroupware database and is
used as the persistent identifier for the team. If the project_Id
already exists and UPDATE is performed for the project's name and
'fakeness', otherwise and INSERT is performed to create the project.
For each project once the update or insert has been performed the route
retrieves the list of access grands (from project_company_assignment in
the OpenGroupware database) and syncronizes the ogo_project_access
table (see below) adding or updating any access grants and removing any
grants no longer present in OpenGroupware.
<br>
<br>CREATE TABLE ogo_project (
<br>  project_id  INT PRIMARY KEY,
<br>  company     CHAR(1) CHECK (company == 'Y' OR company == 'N'),
<br>  name        VARCHAR(60));
<br>
<br>CREATE TABLE ogo_project_access (
<br>  record_id     SERIAL PRIMARY KEY,
<br>  project_id    INT REFERENCES ogo_project,
<br>  object_id     INT NOT NULL,
<br>  permissions   VARCHAR(20) NOT NULL);
<br>
<br>NOTE: By default this route will only look an 'not fake' (is_fake
== 0) projects. But the route will handle both types, you just need to
tweak the first SELECT action. </div>
    
</div>

                        
                        <div>
    
</div>
                        
                    </div>
                </div>
            </td>

            
        </tr>
    </tbody>
</table>

<hr class="netscape4" size="">

<div class="footer">

<a href="http://plone.org/">
<img src="BIE%20Integration%20Work%20Flows_files/plone_powered.gif" alt="Powered by Plone" title="This site was built using the Plone Content Management System. Click for more information." border="0" height="30" width="96">
</a>

<!-- 
     
     Please keep the Plone Powered button (or a textual link to us) if you use 
     Plone on your site. It's a nice token of gratitude, and we appreciate your
     help in promoting the Plone name. 
     
     Plone is powered by the combined forces of Zope and CMF, two absolutely
     great systems made by Zope Corporation (http://zope.com) and they in turn
     are based on the best programming language in the world - Python
     (http://www.python.org). We owe these guys a lot, thanks for making Plone
     possible!
     
 -->

<br>


Plone is Copyright © 2000-<span>2006</span>
by
<a href="http://limi.net/">Alexander Limi</a>,
<a href="http://www.runyaga.com/">Alan Runyan</a>,
<a href="http://blacktar.com/">Vidar Andersen</a>.


<hr class="netscape4" size="">

<strong class="netscape4">
If you can read this text, it means you are not experiencing the Plone design at its best.
Plone makes heavy use of CSS, which means it is accessible to any internet browser, 
but the design needs a 
<a href="http://www.webstandards.org/upgrade/">standards-compliant browser to look like we intended it</a>. 
Just so you know ;)
</strong>
 
</div>


</body></html>